/* ***************** Menu In Role Table ********************* */
if exists (select * from sysobjects where id = object_id('dbo.[sys_MenuInRole]'))  
	drop table [sys_MenuInRole]
GO

Create Table [sys_MenuInRole]
(
	[ID] int identity(1,1)	not null,	 
	[MenuID] int			not null,     		 
	[RoleName] nvarchar(20)	not null,
	[Authority] smallint	not null, 
	CONSTRAINT PK_sys_MenuInRole PRIMARY KEY  ([ID]) 
)
GO

 